SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001894 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001894 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103269,666971,740658,829400,720026,587384,315255,265799,934128,294993,62181,223158,946080,856057,558240,722783,103198,966070,299587,930839,923117,405308,215273,973507,947583,624107,114330,493105,313594,510381,481162,364488,554155,819079,486412,225286,434918,338672,1018609,511036,294800,96665,679217,571480,730979,620772,110890,207057,681170,892889,590217,609915,177699,295994,1012558,500846,377138,707328,379484,663669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]