SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 175343 LIMIT 1 [ RunTime:0.000635s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 175343 [ RunTime:0.002471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420738,529745,810943,666578,701142,577314,954863,417023,748723,250906,312936,32070,523536,905601,178285,581292,903736,279386,932689,515910,637185,1036839,481361,541145,986487,278537,988394,751964,279910,292537,311663,291249,517481,650606,264153,110309,444745,265144,396546,763055,1012711,706067,865533,1048426,582679,491017,835627,574368,2578,815088,179766,553531,845100,1018736,258140,1025868,331934,297130,103192,347955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 175343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 175343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]