SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 288530 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 288530 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524981,927413,791576,615595,807714,266455,1018059,636654,757992,164052,782703,1034819,883961,900077,626639,299058,316987,994935,1004798,895516,717571,1037424,605665,69314,510830,975322,844677,5799,937636,308432,76104,241791,420519,285170,153970,477984,906902,462370,272615,970794,342770,975579,975474,445826,218097,207696,165568,384486,66571,113798,710302,743191,1023203,185340,206765,155716,714378,739719,609667,354168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 288530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 288530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]