SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001592s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500475 LIMIT 1 [ RunTime:0.001946s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500475 [ RunTime:0.004487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101963,140642,653627,150936,941687,987605,66871,919029,713362,456839,480118,375459,123356,96754,789294,1085,706055,187836,886396,17157,82877,508014,1040216,653319,75262,592207,868977,961216,561988,320647,636274,581342,589685,6614,875480,774460,59373,593183,960757,274665,634005,137037,768513,127217,718812,96173,433858,870929,50816,69005,996160,826600,718290,885734,858029,319930,448707,425243,973877,681182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]