SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045455 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045455 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5254,830020,579434,783431,259007,892432,370266,586085,407946,300961,191486,895821,132323,40097,826643,768801,70816,263128,1026899,194380,869271,828503,135518,782452,221949,171313,87311,711366,890404,586841,604270,389110,840530,344203,466185,220396,828253,824380,384573,34255,695669,328593,577067,779083,843363,818045,370773,369782,837358,524977,774832,372076,818963,581142,865703,655314,363932,974622,277848,267222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]