SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005800s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502041 LIMIT 1 [ RunTime:0.004625s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502041 [ RunTime:0.007638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266080,263422,314549,836717,219850,286954,580304,766929,595414,379935,953701,34314,472012,711449,902779,1023069,885725,408744,487628,956646,780670,515157,194314,299246,914164,595308,1018414,359467,846395,474636,1044554,388932,791053,708385,692907,165779,923259,809249,1004116,834814,255700,116781,568482,482538,496681,710438,663529,111326,724376,118257,122005,97089,138511,539854,240800,893116,185192,511870,154342,343397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]