SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467643 LIMIT 1 [ RunTime:0.000694s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467643 [ RunTime:0.002049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899045,160167,629619,107060,242136,129170,865633,525642,380145,470479,771796,688653,92240,806099,758810,33436,712016,555606,8909,352337,417991,368443,392699,242048,919357,966960,308678,328420,628395,896001,1036963,194869,434904,428492,1029231,737269,7207,240070,377082,295622,957496,474784,552698,733279,221100,723879,495307,430885,776393,577411,620930,300693,972692,944083,763102,220963,705307,136670,730930,357117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]