SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340420 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340420 [ RunTime:0.002151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901223,695220,1030965,1022128,213288,468557,7454,58713,711300,176051,692332,281866,982193,573125,102316,72448,381722,131153,856945,330291,413280,504026,634417,721250,431074,829246,784246,28330,66383,535120,30623,1031154,154637,1005514,768139,354635,1001312,847140,929277,656910,86092,1043181,767781,810736,916716,319378,456987,238917,122928,382159,281918,36871,571997,421091,66063,829880,179955,133554,513366,1021890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]