SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309191 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309191 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74700,153781,384203,612213,542489,656460,759005,252991,248152,883110,293062,595014,497581,869798,18959,791669,200869,354858,405415,247065,786693,739443,1001773,86928,398391,331872,603838,200579,696626,819098,586837,975967,241399,539953,565210,820124,875802,552748,820625,612811,871379,73107,417010,484298,146303,793345,661347,638406,253880,180135,269755,268232,236409,1044318,648002,302758,358447,530076,200511,289817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]