SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447601 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447601 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206861,668947,408533,994365,896717,361536,151475,251984,906346,34467,572528,888749,1004858,754260,269627,550951,442903,569369,834422,140430,328972,298295,15149,609643,34204,103805,548521,245983,224119,1045289,635090,345858,950994,598550,887089,118261,149656,822438,1047804,327346,995658,926762,669541,398841,411308,261580,644419,737948,606285,668347,638520,56254,107692,576812,12,854385,636356,897016,554614,27865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002271s ]