SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040141 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040141 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193702,920083,780450,46783,650472,935463,533227,232201,809729,888253,364723,125281,1031838,354374,453016,805462,810604,25917,928419,605665,640668,69898,401906,1029743,837980,52113,724651,231953,101268,94572,283064,171074,214958,199991,761875,115544,259771,390708,618966,559725,774026,153404,797201,471448,799610,477020,817876,495194,737111,692171,921226,323893,512522,70350,913481,775948,648267,679198,267937,524248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]