SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001792s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901028 LIMIT 1 [ RunTime:0.000516s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901028 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362608,717227,89704,523044,197426,539753,788116,492721,799395,792550,869655,677228,467524,40749,907628,838204,56669,440036,275409,100613,901626,229512,181588,961384,159790,669966,1040579,927950,503392,913310,483975,291912,267919,271794,540949,154495,990261,397703,915107,239343,534355,734637,449567,370719,291546,223206,489439,539439,95504,663715,216448,1046855,857772,77983,997670,923078,476620,659133,477340,388596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001604s ]