SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145013 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145013 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272913,975334,97002,682399,201224,69984,913568,803083,966222,541949,877632,789940,65303,296803,427074,121636,721242,856878,185802,583119,320895,321252,121898,358590,694298,565076,851564,766159,990247,615159,626885,344384,200805,516737,448933,577044,616370,868727,566495,506277,182163,936290,644181,439559,889652,372407,931040,675109,786556,164072,471456,56870,876828,707212,193326,263565,916391,674865,845093,273772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]