SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598528 LIMIT 1 [ RunTime:0.000867s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598528 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445158,55324,23866,811653,27997,320358,1006273,516991,430118,866118,809452,443844,341527,33585,220126,563158,228548,731406,214615,943917,1040860,214533,444831,729298,405897,821808,973102,287303,601875,804022,184990,18045,378942,168129,947060,760643,616469,628297,123243,832563,914850,946148,708768,767829,5854,676842,449728,546728,540586,814738,943275,763348,113680,89954,452309,784663,705818,237014,790266,589212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]