SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508078 LIMIT 1 [ RunTime:0.000285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508078 [ RunTime:0.002532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850219,594142,526571,539024,532890,699267,390751,270104,1017014,744235,879886,997239,239138,421948,624396,954650,50404,71661,925914,320262,764205,210733,225577,564487,212147,590528,895923,450579,250615,670674,56417,867055,530824,63360,124597,89544,141418,411533,96295,521607,1031330,923345,980433,955032,316198,957198,96678,679405,624376,652269,458955,496692,367782,468658,129497,305323,382773,572944,553831,279779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]