SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 157091 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 157091 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886295,219361,75987,167127,272777,247034,476908,198162,581948,818769,10846,512015,884106,159204,792960,1028908,135949,554572,718912,444188,1036163,50564,147571,796645,339821,489249,213484,756543,782855,974046,526172,816517,54195,1019028,35585,531355,71505,441433,688977,275285,325517,712475,19622,770471,721546,194602,869730,573196,889887,104650,576956,288872,11408,10658,316681,972128,1030896,210913,118454,907563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 157091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 157091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]