SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504951 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504951 [ RunTime:0.001469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276337,588095,590226,693036,851447,625890,608125,665583,693001,127054,103272,872040,671050,813566,43903,484607,102328,241676,599762,618584,32500,137277,838761,655926,216102,41511,89076,315788,377158,45321,763264,931006,753499,779088,677197,1005629,1000363,46990,245647,621919,610758,826253,190744,942324,402638,756075,256899,615287,379989,394603,134070,385766,495571,379972,220501,944964,382812,1016871,277279,442830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]