SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410222 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410222 [ RunTime:0.001396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614498,1021604,500607,436537,742787,389044,582151,900574,101222,405603,697228,588149,223898,827494,530169,61150,828127,85561,110259,844517,412477,942826,929028,777712,292584,30101,109514,23186,530621,408745,150614,806717,396691,239864,436653,215017,735804,548607,417079,321689,969439,843386,796787,454529,991334,1044426,13808,401127,946670,407766,401096,238231,996986,867096,795163,444438,67414,742220,863793,788803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001625s ]