SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018456 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018456 [ RunTime:0.003712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255375,1033732,720253,227429,1012054,348442,306511,358229,39573,944423,710325,842014,21045,683376,823842,4301,593112,124100,280754,531263,98476,990171,347641,600191,471158,184584,451472,123572,937491,929259,638190,725857,1036067,884550,742889,858143,617214,565225,64482,517804,422805,332591,262537,952088,103730,996464,440599,784522,216195,451211,965122,708954,8124,371397,206453,452985,834348,1029764,34055,751580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018456 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018456 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]