SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046901 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046901 [ RunTime:0.002332s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032904,68586,742638,655582,744637,216992,736637,55535,897273,94932,582915,872632,1008345,670579,509577,648735,529519,840929,970137,691040,238511,39771,180490,204848,484153,277668,455908,427837,1030143,375309,459023,432416,128763,895576,30367,732305,537109,673056,399074,24660,400089,693063,373106,441933,784123,757788,330863,595605,912629,721810,955203,841155,227886,715105,31965,165538,366113,859560,397060,207935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]