SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045140 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045140 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896508,794411,391233,533980,424674,1015229,400261,560925,73957,974618,461159,824084,1031137,298498,41278,461282,831465,1021550,729320,878368,139519,118202,1002456,909841,367993,968838,1002642,943059,159143,605586,73652,650825,924607,355928,146763,953171,289837,1006436,563073,276557,1037243,609196,19892,815312,626302,551325,211550,575671,698173,409801,802837,246421,709385,409566,739038,762589,938851,370245,423699,338624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]