SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039278 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039278 [ RunTime:0.002801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805974,396901,131428,207603,987743,985155,74751,83953,737245,16958,329096,164692,631504,640324,392277,546250,579385,588097,174213,589277,1024020,595429,558876,25524,204378,532963,648620,5344,210765,917159,19978,69641,643219,542290,865587,285850,269870,426578,191506,954470,405003,212637,241846,982905,257252,397403,732263,276340,293682,742484,896907,988570,1023413,82504,531765,713506,83365,862672,673480,73056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039278 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039278 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]