SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530102 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530102 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495526,778875,141893,1043916,782830,457028,223714,206034,31760,403339,945653,770433,42161,625964,754166,955090,1046967,694919,971638,320279,545713,614286,928603,254933,67273,926653,732098,1043262,521028,708286,624820,428213,4576,378324,396572,735836,1018338,163088,889790,599141,702514,913824,428087,900490,896624,564987,758148,1024759,128428,289597,1015374,455648,278818,234771,80509,337908,861284,26147,836170,473132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]