SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105001 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105001 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235300,409523,519612,310597,480137,765745,833510,1045775,4121,341137,992041,980164,188109,485910,1027641,360451,892727,133685,305448,933288,42155,329830,595520,430627,996738,540621,620744,696837,520982,48169,941955,611646,197194,495403,358728,217422,433574,614715,1040593,529370,374427,421858,422348,207609,711965,529106,423036,388960,272800,500059,587618,509492,475809,995128,519310,549736,252642,47931,791147,380951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]