SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574218 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574218 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554064,968608,40634,232721,678645,1042908,25262,63934,800823,403978,1009110,120099,932390,117899,255177,96853,800554,607730,176454,724468,601056,676068,135116,369020,67255,850829,779364,750210,30474,961255,727737,542450,397671,637720,101101,629609,577837,325187,320410,593702,397953,963523,593846,469006,380431,996460,341846,205578,195726,892042,680847,549940,372233,889936,1000821,798011,832747,96030,602487,475885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]