SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264510 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264510 [ RunTime:0.002272s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183456,16986,572190,871813,963829,122447,223368,213821,97066,35148,594753,127918,685578,277000,139043,744998,301,433787,121486,870929,227489,995806,559113,58854,33106,736160,531880,776397,72304,295177,623486,580817,545906,366372,148597,1006502,740399,1010678,315303,688454,985479,24576,79448,920585,1024546,119711,235205,930214,3258,886486,130385,455916,464331,164370,863969,433274,492124,135834,501692,586498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]