SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102629 LIMIT 1 [ RunTime:0.000525s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102629 [ RunTime:0.002712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896003,862886,531638,837494,526846,790933,107680,769783,949716,965131,57178,233863,47071,529347,758402,950623,421963,926177,896212,408695,398407,129370,171639,124887,929279,89385,99490,43479,970679,74299,409981,531710,864751,973100,770333,723862,602298,951726,574724,628618,805317,1001246,736312,923568,485702,959099,135720,178018,819283,186689,82018,776394,802497,301246,377090,469819,196323,635118,68815,499850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002597s ]