SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445049 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445049 [ RunTime:0.002119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449546,430378,987682,262771,712828,888110,669384,677585,120606,90917,868121,712360,832744,148286,288217,954073,285560,572649,910571,445794,507362,126689,821821,38386,214484,59979,93725,272739,294525,688082,642982,836671,781647,215562,44039,513932,1028348,287289,1002009,628169,985322,766153,508128,640131,586718,911636,986394,325246,355577,784272,348822,394826,268887,307905,283023,293391,544971,528982,836868,732553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]