SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 57512 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 57512 [ RunTime:0.004002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369050,742581,403166,352453,516534,689081,792114,813228,938104,373206,903023,378931,876092,307013,520041,545210,700583,1010859,487894,519028,123380,186362,894573,830558,664801,455734,917894,250983,871332,190995,291702,794429,438983,669215,772627,845368,576954,314987,780031,882859,264827,766686,369055,417812,509583,507235,266030,524427,328170,204493,506937,870252,853278,1047807,510248,641529,845903,144553,481109,695023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 57512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 57512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001947s ]