SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403903 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403903 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336587,394967,717209,1009634,429999,341691,66549,121740,752157,251834,787311,701350,544391,418672,402271,128519,103731,69401,540280,192241,991637,823921,160938,133915,134180,127703,314426,952595,971130,361725,321832,340399,444678,287199,216803,716506,958600,301345,621718,608829,949663,530317,968631,95114,51701,96011,457690,557630,236714,268892,852923,642365,590163,450780,474620,205961,551266,435685,1011278,714199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]