SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974008 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974008 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329018,910552,10195,116917,375803,505135,503154,679091,41712,788869,988299,312988,728000,59489,404698,189431,180830,77030,581899,186055,614183,489255,434688,972082,52396,635047,26802,456096,606116,981308,30334,126316,946236,799571,54576,770304,727016,673976,65670,518143,243132,367852,550793,583156,341274,971502,608722,71901,270826,121024,956633,634236,671035,974821,432305,774283,599761,121500,144918,686092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001271s ]