SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596643 LIMIT 1 [ RunTime:0.000842s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596643 [ RunTime:0.002414s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (589576,414468,890490,361487,1011809,837890,451836,126563,232941,291401,706074,437691,997647,4074,682416,872745,50458,926488,112084,309730,558383,225295,120984,135785,40813,326984,139519,844536,789872,315643,790897,803272,730486,181638,432465,549522,34265,499723,981646,383547,996311,197189,931044,1047412,236730,11348,367545,694637,320723,946683,112885,28147,1042954,103869,290303,442711,409492,466914,884356,604374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]