SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001775s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345626 LIMIT 1 [ RunTime:0.003410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345626 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037527,668651,774982,1033804,570993,68421,403054,1031682,283527,976917,200394,204091,955020,394417,851551,803445,1046644,14696,358146,906797,634525,150020,122995,887160,589824,514034,986575,636305,124858,450774,542766,347977,332833,297229,383920,315661,531611,781581,87875,1035680,148124,867225,9155,491419,121893,824029,81662,201966,462573,574909,495916,208143,136471,388195,780562,438239,39058,698507,641630,6081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001728s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000839s ]