SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001084 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001084 [ RunTime:0.002167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322071,92771,496113,609681,23192,972617,423987,298856,289659,228761,742888,504934,846522,242031,336209,455553,951081,30164,976316,669319,362087,960683,130799,338596,930717,284014,261023,413699,472916,899473,468997,780867,628765,389612,713158,344571,424145,152344,245154,418090,822636,999583,92055,211616,829449,371221,277733,628009,91131,717486,303771,782962,249847,243479,431272,414392,552294,538289,592568,375863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]