SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004523s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539031 LIMIT 1 [ RunTime:0.002031s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539031 [ RunTime:0.007545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519166,514193,589481,81552,658672,240625,681229,78635,572687,469700,16291,737533,507035,533623,740782,526734,332521,209281,153489,1037969,380396,193299,78485,522332,343428,899595,356977,331539,694342,691062,526370,257313,646123,999875,559074,681125,341922,519189,312849,353629,422384,364958,151238,656490,495676,1026529,266004,447955,34509,770357,50115,146053,918355,610530,228438,544584,59058,867855,756972,592121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001799s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001221s ]