SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023120 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023120 [ RunTime:0.002466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (795880,1045410,247068,921152,604426,61968,372876,144792,398604,931246,461277,717786,825162,675781,828094,870117,213134,402914,656827,484722,579674,692872,776174,30338,537680,495053,435290,291473,791107,475125,218546,180159,697583,787886,312989,205238,461827,411737,235099,892510,826096,650338,483977,815556,274421,981472,403739,36204,592266,1037329,123146,239712,143048,189869,673306,237057,744420,589912,373315,116908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]