SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003482s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809623 LIMIT 1 [ RunTime:0.001229s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809623 [ RunTime:0.002205s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (797166,731468,633922,781319,772940,224766,216307,229714,847557,546830,542316,218107,811944,83795,125131,197153,41197,930239,606327,372800,731275,190805,481240,118070,153612,909567,765260,826297,93855,221462,721280,439860,82382,486818,853710,198442,934225,890763,19780,74208,991072,767497,534340,837794,982727,462985,169230,111797,495610,88023,69060,383005,162176,498137,548377,516726,209827,737460,411925,792601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]