SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589881 LIMIT 1 [ RunTime:0.005017s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589881 [ RunTime:0.004335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696597,466702,50731,807945,785994,410176,1000105,604069,855492,1016582,229334,679955,1046001,769176,862301,75717,451257,575335,739120,619205,703701,623974,644013,97812,330205,168872,714471,242904,507975,806502,110644,704250,834432,290056,995851,137359,203307,66455,395262,643496,300203,601192,1025442,472924,265924,525701,600342,1030137,498643,822356,387595,703338,80962,112196,524638,617432,15736,802370,46625,745980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001825s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002018s ]