SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518187 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518187 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762673,417419,696508,256382,463809,1001817,260680,153226,109960,278433,202348,397371,604596,447171,514266,608010,542299,408613,975220,921426,478431,120407,568579,777817,698026,587098,273613,265634,874255,94606,812096,382253,669556,157066,58445,282431,766748,514256,348268,184036,1016808,801984,429340,2028,577143,934406,307683,772434,364590,321634,740945,823598,415087,139099,435249,243225,454629,945643,357134,172873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]