SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438169 LIMIT 1 [ RunTime:0.001494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438169 [ RunTime:0.002933s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914295,1000424,717067,276803,935472,161169,777438,141788,155287,416026,434666,59286,278654,196543,780801,85515,1002756,745857,464283,273589,892262,437359,534886,607392,567862,79733,705642,523495,40027,297480,649892,850358,159241,945117,286800,507224,75211,159220,129383,240016,695165,1003243,37140,931134,315293,19771,948516,676525,807340,262739,565628,92991,502585,396149,237401,922997,480900,300821,714025,542644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002339s ]