SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421891 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421891 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269384,995027,932816,37668,328053,928038,645440,820439,569553,398471,647954,351969,823778,340172,297008,101164,890366,743568,404603,149851,936182,359841,740502,603428,942973,150011,973649,251270,548796,426843,357367,747361,644614,353443,1039047,840187,678770,29952,525939,1010500,314739,741334,812209,234635,561624,69246,79766,639927,5281,614509,377482,473622,797159,711854,777371,684148,766672,309121,1019472,1003755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000382s ]