SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001577s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328811 LIMIT 1 [ RunTime:0.000947s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328811 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1937,675253,469377,201299,494054,289452,285456,19273,292868,273625,713935,148034,840118,732474,330064,993920,928264,7058,794126,232124,46298,86975,243799,472676,86434,544532,828879,340391,944784,549648,74721,894474,275029,270537,778225,543688,456311,637019,334935,230112,418285,546907,548526,533906,911764,636803,15817,950240,558803,54513,979756,227660,1025868,189817,771552,959163,367963,926490,859336,653367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000685s ]