SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542831 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542831 [ RunTime:0.001468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544207,694797,877041,491449,235019,888799,669285,767091,705677,611237,362346,302136,98819,438937,902792,391593,938530,710235,707865,815703,887757,83245,720807,184540,906543,885354,564007,412098,527138,766388,143674,797015,739326,137423,457184,466345,716388,1024983,234520,1014231,221964,567174,826258,844236,36729,772002,209310,746045,648008,655780,386327,490201,150938,937083,625773,67197,514724,606807,499633,782791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]