SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 14228 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 14228 [ RunTime:0.001316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576757,641630,608147,1027921,495928,329506,854757,408708,669739,100498,377393,732927,23118,667135,790611,176174,470749,167954,555031,626206,78523,147356,97781,299808,883069,704700,400229,434324,797725,728523,498855,151612,831092,529158,757409,135174,65547,351652,215649,365522,176079,123685,938120,1025668,282944,545194,615397,334813,295711,818246,438292,574729,364156,725770,239729,756777,142717,803954,861135,973198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 14228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 14228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]