SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 172813 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 172813 [ RunTime:0.003071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544051,484801,274512,269857,711659,568757,703873,532283,420965,290728,572185,461498,106622,832601,27210,307668,937435,927381,669135,335631,68735,807454,660364,489169,319823,255993,450350,247524,587710,118088,811409,549367,1014638,323521,300566,1000963,561596,438789,845491,59584,414277,883263,1008544,899987,77652,465773,530693,851418,542744,370284,528421,953877,978308,196435,169235,823829,958225,240902,670833,833405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 172813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 172813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]