SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596120 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596120 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802187,582875,235092,241758,233755,3714,242937,777657,673666,412124,949441,501958,164055,407596,865203,832714,906351,806257,87459,354673,910229,105139,564270,326597,430560,734777,337137,371072,1029742,890191,269741,459788,843785,103754,1036130,935403,78014,991346,569330,794447,261340,979050,249271,790794,612643,906814,606469,645081,127237,512804,373787,838811,34464,406051,128265,352481,984322,934959,577681,801747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]