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` = 29981 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29981 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469518,239374,377985,86229,736136,177700,612210,779013,1006231,828732,171016,829489,121424,973048,964632,12740,162420,87029,490535,567071,984667,61702,625674,63148,96868,825993,477045,467177,131752,617371,269577,435344,62982,496170,940565,231960,3437,538835,762136,828719,1032422,298293,702700,148528,241388,491909,85691,379237,86306,418376,87486,482463,643817,334337,742407,110205,661510,905594,446135,971224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]