SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040070 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040070 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97573,953711,718090,273960,24775,270561,968245,397948,224041,86076,640927,809739,860289,86643,474590,617395,280015,637123,789195,345616,450991,120158,87420,152533,270254,1014170,400753,107871,651796,513258,677583,931898,713009,484694,293355,887007,645221,993750,192704,325011,875477,669208,588800,610614,734383,944333,1004652,189326,974847,165336,301442,757932,284658,1106,586392,108155,694832,636403,624655,778154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]