SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 272083 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 272083 [ RunTime:0.002493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215608,813344,194229,87985,25047,948562,293988,970215,1028974,120941,1013542,615780,601948,610414,849852,324045,243256,655864,42066,159430,512076,333329,545804,217558,888190,1014482,711340,978912,473597,263523,258998,514356,252489,378511,180474,354088,203776,592959,799268,257611,196344,570718,815218,94591,636637,987121,45718,540156,535000,70591,746296,770543,902244,726707,1039048,376640,76508,907119,620932,84227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 272083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 272083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]