SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002583s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348914 LIMIT 1 [ RunTime:0.000677s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348914 [ RunTime:0.003827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233700,731113,986626,395573,629617,331580,1000503,909972,507339,1043042,412107,147551,248491,512535,381457,258092,513393,792625,33571,304842,738102,990648,971862,195667,503760,328811,962709,709347,795090,962187,343528,1006847,355573,515498,27153,279928,162926,927679,239434,907939,591272,756729,408184,96411,810699,136615,170125,983496,456355,522032,1042609,933062,38478,784080,767817,963009,704851,666920,54902,525976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001130s ]