SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017618 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017618 [ RunTime:0.002909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37544,459513,548089,66906,783332,756812,612175,226770,608160,893412,461787,922120,1011567,554296,461856,711433,524076,273053,88269,27557,440343,370908,405191,670644,589389,445579,125609,601830,906881,680167,1016955,988328,950418,952809,939679,681127,752878,55678,665480,796086,940553,866653,31770,92871,709787,284055,691360,507726,532030,235048,134514,327354,92499,544838,717490,778666,799071,175767,213893,80773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]