SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019536 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019536 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872274,285617,558951,176238,329293,469857,626872,532350,482620,399565,506555,696112,240790,653924,921109,465003,975483,638964,731746,840862,708095,124386,364593,618913,537133,903315,955916,525774,64018,754364,1004836,435057,332019,948686,378383,272079,94236,304523,952593,707307,696188,243875,14002,450335,220748,627418,175594,661027,411576,755253,162266,178204,158971,28710,43379,28816,983454,449596,759182,557233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019536 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019536 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]