SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367896 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367896 [ RunTime:0.003373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96518,824070,620578,475799,156584,446291,936412,611639,542467,690334,76484,341175,480009,45346,389691,338009,852958,786339,8227,993653,499158,809903,1037084,306002,711096,1014947,968271,109564,382443,1033403,371448,573980,782061,480468,357412,267213,833845,947883,131723,339119,21991,754566,947018,180123,996846,506762,473201,840597,941714,365073,111402,739610,227166,542684,972861,552190,1033827,946444,130339,1021583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001558s ]