SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511515 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511515 [ RunTime:0.002649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608806,332713,770726,442940,202615,805220,613172,661590,656544,458677,565110,105950,222329,776866,1039809,442139,247574,727541,649791,300040,927982,650811,969762,677517,434860,826901,911765,956761,245833,939196,496915,561019,265222,861692,315833,254061,995294,198654,839678,414680,928982,716127,274689,536035,540029,749342,406112,118470,523483,333768,21069,956674,209196,195866,553259,643924,821314,626454,189261,302656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]