SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347593 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347593 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270744,699258,818574,15194,465565,169513,68004,936034,847142,270420,724772,366656,153769,291183,659785,1039240,500363,594657,480381,743600,796040,576924,378269,831327,756703,131607,690825,471905,542123,795422,85330,335124,722325,1001875,6860,592183,326465,877648,467563,228956,38677,369750,500772,90146,657038,378872,221638,507239,1016892,193343,737321,380094,307362,660154,45625,961402,397056,898339,390553,891341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001323s ]