SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567823 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567823 [ RunTime:0.002126s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143482,338052,11860,708624,633601,571810,884721,231364,671250,214748,878535,186821,40697,672083,700391,1041465,165522,299306,60719,62725,488013,148177,144599,137197,258331,402923,814106,980720,222723,250957,403109,33788,210252,818100,777427,1013943,1026010,380336,113701,567423,433588,832306,1033379,865581,446105,638349,300701,617005,909554,219054,86247,1047806,584950,141351,63829,980036,897879,219398,290551,400681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]