SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 919053 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 919053 [ RunTime:0.003413s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538381,489664,421013,172116,536825,963929,929048,986227,381497,189538,13492,883053,702158,79022,379576,398356,1032639,388969,654208,801857,658010,1031655,310520,352951,13603,498268,655593,116663,86558,141949,494101,461334,98212,300624,425829,473220,390998,898997,742064,218579,214759,249443,696249,854483,644483,196073,224343,1014639,636338,16032,369146,736484,141245,939253,370920,421391,661425,45648,499542,113346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 919053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 919053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001190s ]