SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019254 LIMIT 1 [ RunTime:0.000973s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019254 [ RunTime:0.002660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112583,27131,11168,507712,474701,780290,952673,907204,704640,504247,410888,911672,585026,357189,321659,978047,523709,460242,435113,276577,244666,697330,101580,858414,499009,274054,977531,959418,642351,884767,63835,27754,821914,328441,164051,1036638,610576,606332,503916,918915,233736,502969,186204,948064,418375,206038,522977,942994,932445,281910,715316,1041494,717962,845718,408867,668383,1044352,929335,819250,389879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001911s ]