SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507796 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507796 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408312,1011544,1034845,141220,564323,332940,340989,31266,450052,652602,834448,424052,258159,355447,473090,491028,457340,786325,129123,705060,11654,867455,1017737,757091,504408,710000,538728,27824,234955,920653,784186,35134,531077,582382,570811,278730,392952,1030538,55906,367294,510073,665915,791999,420569,867463,159997,850256,987432,864645,721631,1023535,295301,44571,160035,498048,611075,332234,880425,897804,869087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]