SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506814 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506814 [ RunTime:0.002268s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017621,543014,102052,478036,819837,461923,280748,93779,861530,219832,158533,142236,862713,208225,980551,612259,182438,787031,560260,276088,289486,503136,437280,695244,69665,338857,116804,1028894,55021,822457,541935,746149,972801,93999,543231,97119,227455,817140,221544,330366,255290,296670,499206,993427,432184,1009167,622385,944334,248413,771517,214135,157997,1001581,312476,901259,250228,649619,470461,23564,500529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]