SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333111 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333111 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540308,831061,239232,952551,937319,39199,25148,487490,439148,486309,720008,1010219,971875,335503,557629,38580,104480,901636,881114,626413,190308,334758,1029811,899727,826311,1024660,112791,365855,438975,1027511,264239,467394,561503,643781,580750,879002,78514,927150,459710,950911,789147,388078,224053,1035557,350857,898369,887140,784736,541870,466086,741445,322220,152349,775729,415921,425690,817700,28885,766841,568699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]