SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001999s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526521 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526521 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (792180,395064,484860,3579,786717,691944,193710,822959,475734,46603,342885,298497,469633,619807,84593,564910,324581,845778,935144,640029,46014,282488,50529,204240,74135,808848,999095,444585,960282,169627,1028942,75493,721996,185615,672320,490069,649365,799401,564217,354977,103137,787607,275921,794252,430669,935521,712211,431272,97197,751452,67064,362144,72141,329074,455422,45214,188939,494463,88409,220694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]