SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 948191 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 948191 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538405,134866,239227,24243,110018,221810,644678,1009326,922733,1025691,95023,302771,953647,261271,37224,964167,818894,870356,45161,739260,1017258,736401,1033019,84289,377130,212813,413861,4857,971018,150844,193149,273654,502320,608907,541169,905413,453810,71499,655832,714463,363329,220243,456851,676416,178234,463466,263333,779368,431311,275240,15382,125375,698865,314932,828856,458180,261015,936517,637592,508863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 948191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 948191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005784s ]