SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109501 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109501 [ RunTime:0.004411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722630,81828,487018,683238,351764,736575,816927,633870,316360,369873,245178,407806,342240,543477,735590,197946,394610,774168,585658,570129,483624,585768,276737,971721,330876,13336,669712,302813,794355,543540,901324,898410,161669,461453,161114,481593,432637,68375,436598,859737,515280,593787,894624,863578,189031,595078,576356,18113,144108,748642,242891,726216,726548,116039,653188,376849,400323,273829,552426,875158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]