SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006754s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333876 LIMIT 1 [ RunTime:0.000827s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333876 [ RunTime:0.003239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466008,1041105,195558,95938,496564,430361,469381,860897,910581,393446,829355,115805,1006492,362559,722305,682999,500924,319978,286259,540678,685202,903090,649392,98135,26814,554297,593531,181761,89675,727031,231449,386808,1031053,783343,511137,1006950,201358,999670,306045,504625,291798,551243,738714,837378,404715,15724,513023,31753,979615,668828,195657,788346,530821,830587,363254,181177,656640,655665,649366,748541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]