SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34011 LIMIT 1 [ RunTime:0.000551s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34011 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461081,1001900,668612,426227,345887,857254,197395,659587,838373,19614,903698,736812,472329,710447,129991,740507,436439,82371,169282,211353,516194,466564,747925,709997,975714,104559,31747,655446,637858,85414,676447,92966,644714,850971,502638,923687,962230,291839,308241,444637,174688,12515,1029588,98148,14905,746507,196161,171142,508593,266721,1006268,462679,672944,31053,668132,8386,289841,703197,742152,406160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004775s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]